10. Application Retrieval

10.1 Introduction

The Oracle Financial Services Lending and Leasing system includes archiving and retrieving feature that provides you with the capability to archive old data and store it in a different table.

10.2 Archiving / Purging

The system batch process runs the purge / archive feature based on the system parameter setup. The system archives the following items:

• Applications and related data
• General ledger data
• Securitization related data
• Producers
• Producer transactions
• Account statements
• Vendor assignments
• Vendor invoices.

The system purges the following items:

• Job request data
• User logins
• Output data dump related data.

In the system, archiving is a two-way process:

1. All the archived data is moved and stored in O tables.
2. The archived data in the O tables is then moved and stored into OO tables.

You may set the “default days” for the archive feature by setting the following system parameters on the Administration screen. The parameters marked with _O are the items moved from O to OO tables. The other parameters are the items moved to O tables.

Parameter	Default Days	Description
PAP_ARCHIVE_DAYS	999	Purge Days for applications Level 1: PUR_APP_STATUS_CD is used to decide applications with what status are purged
PAP_OARCHIVE_DAYS	999	Purge Days for applications Level 2
PGL_ARCHIVE_DAYS	999	Purge Days for GL Level 1: No of days after the GL txn was cre­ated
PGL_OARCHIVE_DAYS	999	Purge Days for GL Level 2
PJR_PURGE_DAYS	999	Purge Days for Job Request Level 1: No of days after job request completion date
POD_PURGE_DAYS	999	Purge Days for Output Data Dump Level 1: No of days after process run date
PPR_ARCHIVE_DAYS	999	Purge Days for Producers Level 1: No of days after the Producer status is set to active and there exists no “Not Purged” account with this producer name.
PPR_OARCHIVE_DAYS	999	Purge Days for Producers Level 2:
PPX_ARCHIVE_DAYS	999	Purge Days for Producer Txns Level 1: No of days after the Pro­ducer txn was created
PPX_OARCHIVE_DAYS	999	Purge Days for Producer Txns Level 2:
PUL_PURGE_DAYS	999	Purge Days for User Logins Level 1: No of days after the Login End date
PVA_ARCHIVE_DAYS	999	Purge Days for Vendor Assign­ments Level 1: No of days after the Assignment Date and assign­ment Code in COMPLETED, VOID, CLOSE
PVA_OARCHIVE_DAYS	999	purge Days for Vendor Assign­ments Level 2:
PVI_ARCHIVE_DAYS	999	Purge Days for Vendor Invoice Level 1: No of days after the Assignment Date and assignment Code in VOID, CLOSE
PVI_OARCHIVE_DAYS	999	Purge Days for Vendor Invoice Level 2:

10.3 Retrieving an Archived Application

You can retrieve archived applications using the Application Retrieve screen. You can retrieve only archived applications.

To retrieve an archived application

1. On the Oracle Financial Services Lending and Leasing Application home screen, click the Origination master tab.
2. Click Application Retrieval link.

The system opens Application retrieval Search screen.

3. Use the Comparison Operator and Values fields to create the search criteria you want to use to find an application.

For more information about creating search criteria, see Searching for an Application chapter of this User Guide.

4. Click Search.

The system locates and displays all the applications that meet your search criteria on the Results screen.

Applications are sorted by priority and application number.

Field:	View this:
Company	The company of the application.
Branch	The branch of the application.
App#	The application number.
Date	The date of the application.
Title	The title (applicant name) of the application.
Product	The product of the application.
Status	The status of the application.
Sub Status	The sub status of the application.
Producer	The producer of the application.

5. Select the application you want to work with and click Retrieve.

The system loads the application in the Applications screen.

You are now ready to begin work on the application.